Data Lake - Pandas Profiling Report V2

Dataset statistics

Number of variables	20
Number of observations	2353651
Missing cells	519
Missing cells (%)	< 0.1%
Duplicate rows	4501
Duplicate rows (%)	0.2%
Total size in memory	359.1 MiB
Average record size in memory	160.0 B

Variable types

NUM	11
BOOL	5
CAT	4

Warnings

Dataset has 4501 (0.2%) duplicate rows	Duplicates
`PJ_UF` is highly correlated with `PF_UF`	High correlation
`PF_UF` is highly correlated with `PJ_UF`	High correlation
`PJ_IDADE_ABERTURA` has 38132 (1.6%) zeros	Zeros

Reproduction

Analysis started	2020-09-18 01:16:49.731632
Analysis finished	2020-09-18 01:25:15.682814
Duration	8 minutes and 25.95 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

CPF
Real number (ℝ_≥0)

Distinct	1242061
Distinct (%)	52.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.321659378e+10
Minimum	1163
Maximum	9.999999417e+10
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1163
5-th percentile	897673140
Q1	4689856641
median	1.454638265e+10
Q3	6.350147332e+10
95-th percentile	9.233644227e+10
Maximum	9.999999417e+10
Range	9.999999301e+10
Interquartile range (IQR)	5.881161668e+10

Descriptive statistics

Standard deviation	3.272118334e+10
Coefficient of variation (CV)	0.9850854531
Kurtosis	-1.148330434
Mean	3.321659378e+10
Median Absolute Deviation (MAD)	1.348465013e+10
Skewness	0.6310504199
Sum	7.818026917e+16
Variance	1.070675839e+21
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
596634307	269	< 0.1%
8.593706135e+10	181	< 0.1%
3077961326	117	< 0.1%
5.849690417e+10	110	< 0.1%
1.816014681e+10	57	< 0.1%
2.804770265e+10	54	< 0.1%
9.959913929e+10	50	< 0.1%
1.372061577e+10	48	< 0.1%
8086283640	48	< 0.1%
9939804733	43	< 0.1%
7.504062073e+10	43	< 0.1%
6400472380	41	< 0.1%
6996085705	41	< 0.1%
7.483854723e+10	40	< 0.1%
8110434444	39	< 0.1%
5.359502569e+10	38	< 0.1%
7.654310227e+10	38	< 0.1%
5411242770	38	< 0.1%
4.263765177e+10	37	< 0.1%
7.927082477e+10	37	< 0.1%
5363279479	37	< 0.1%
1.80463648e+10	37	< 0.1%
1047188708	36	< 0.1%
1103637797	36	< 0.1%
8.626575076e+10	35	< 0.1%
Other values (1242036)	2352101	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1163	1	< 0.1%
1910	1	< 0.1%
5150	1	< 0.1%
41203	7	< 0.1%
44130	1	< 0.1%
80527	1	< 0.1%
83623	1	< 0.1%
85677	2	< 0.1%
88692	1	< 0.1%
100145	1	< 0.1%

Value	Count	Frequency (%)
9.999999417e+10	2	< 0.1%
9.999989713e+10	1	< 0.1%
9.999972277e+10	3	< 0.1%
9.999932312e+10	1	< 0.1%
9.99992851e+10	2	< 0.1%
9.999897127e+10	2	< 0.1%
9.999891217e+10	1	< 0.1%
9.999880712e+10	3	< 0.1%
9.999863737e+10	1	< 0.1%
9.999862927e+10	1	< 0.1%

PF_SITUACAO
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	2320023
0	33628

Common Values
Chart

Value	Count	Frequency (%)
1	2320023	98.6%
0	33628	1.4%

PF_SITUACAO_RFB
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	2348843
0	4808

Common Values
Chart

Value	Count	Frequency (%)
1	2348843	99.8%
0	4808	0.2%

PF_IDADE
Real number (ℝ_≥0)

Distinct	118
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	42.07646546
Minimum	1
Maximum	121
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1
5-th percentile	25
Q1	33
median	41
Q3	50
95-th percentile	62
Maximum	121
Range	120
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.641799
Coefficient of variation (CV)	0.2766819616
Kurtosis	-0.2429688722
Mean	42.07646546
Median Absolute Deviation (MAD)	8
Skewness	0.3970920001
Sum	99033315
Variance	135.531484
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38	81627	3.5%
39	80389	3.4%
37	76957	3.3%
35	76060	3.2%
40	75457	3.2%
41	74380	3.2%
34	73966	3.1%
36	73633	3.1%
33	72556	3.1%
42	70890	3.0%
32	70326	3.0%
43	68902	2.9%
44	66267	2.8%
31	65246	2.8%
45	62549	2.7%
46	61229	2.6%
30	58280	2.5%
47	57763	2.5%
48	57587	2.4%
29	55931	2.4%
49	55803	2.4%
50	54647	2.3%
28	50898	2.2%
51	50878	2.2%
52	50250	2.1%
Other values (93)	711180	30.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	31	< 0.1%
2	65	< 0.1%
3	83	< 0.1%
4	39	< 0.1%
5	31	< 0.1%
6	53	< 0.1%
7	26	< 0.1%
8	40	< 0.1%
9	57	< 0.1%
10	47	< 0.1%

Value	Count	Frequency (%)
121	7	< 0.1%
120	7	< 0.1%
118	2	< 0.1%
116	3	< 0.1%
115	1	< 0.1%
114	2	< 0.1%
113	3	< 0.1%
112	2	< 0.1%
111	3	< 0.1%
110	6	< 0.1%

PF_GENERO
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	519
Missing (%)	< 0.1%
Memory size	18.0 MiB

1	1184010
0	1169122
(Missing)	519

Common Values
Chart

Value	Count	Frequency (%)
1	1184010	50.3%
0	1169122	49.7%
(Missing)	519	< 0.1%

PF_UF
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.775776868
Minimum	1
Maximum	27
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	11
95-th percentile	20
Maximum	27
Range	26
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	6.111339127
Coefficient of variation (CV)	0.7859457943
Kurtosis	-0.04350017686
Mean	7.775776868
Median Absolute Deviation (MAD)	4
Skewness	0.9181389931
Sum	18301465
Variance	37.34846592
Monotocity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1	328695	14.0%
2	205573	8.7%
3	187624	8.0%
4	177616	7.5%
5	163855	7.0%
6	162294	6.9%
7	156848	6.7%
8	133572	5.7%
9	111138	4.7%
10	84503	3.6%
11	65072	2.8%
12	64676	2.7%
13	58946	2.5%
14	56733	2.4%
15	56028	2.4%
16	54145	2.3%
17	52809	2.2%
18	46428	2.0%
19	40948	1.7%
20	37377	1.6%
21	33984	1.4%
22	22050	0.9%
23	20403	0.9%
24	18721	0.8%
25	6977	0.3%
Other values (2)	6636	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	328695	14.0%
2	205573	8.7%
3	187624	8.0%
4	177616	7.5%
5	163855	7.0%
6	162294	6.9%
7	156848	6.7%
8	133572	5.7%
9	111138	4.7%
10	84503	3.6%

Value	Count	Frequency (%)
27	954	< 0.1%
26	5682	0.2%
25	6977	0.3%
24	18721	0.8%
23	20403	0.9%
22	22050	0.9%
21	33984	1.4%
20	37377	1.6%
19	40948	1.7%
18	46428	2.0%

CNPJ
Real number (ℝ_≥0)

Distinct	1180405
Distinct (%)	50.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.170408305e+13
Minimum	455000107
Maximum	9.7711797e+13
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	455000107
5-th percentile	4.386387e+12
Q1	1.3872232e+13
median	2.2026568e+13
Q3	2.9237713e+13
95-th percentile	3.50093755e+13
Maximum	9.7711797e+13
Range	9.7711342e+13
Interquartile range (IQR)	1.5365481e+13

Descriptive statistics

Standard deviation	1.101441204e+13
Coefficient of variation (CV)	0.5074811043
Kurtosis	7.257497452
Mean	2.170408305e+13
Median Absolute Deviation (MAD)	7.666096e+12
Skewness	1.310274707
Sum	5.108383678e+19
Variance	1.213172725e+26
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.379503e+12	106	< 0.1%
1.0609938e+13	103	< 0.1%
9.24845e+12	100	< 0.1%
7.715251e+12	92	< 0.1%
7.774211e+12	91	< 0.1%
5.021025e+12	91	< 0.1%
2.8016077e+13	84	< 0.1%
9.116860002e+11	83	< 0.1%
1.5334477e+13	83	< 0.1%
2.276269e+13	82	< 0.1%
5.586590002e+11	80	< 0.1%
1.0014536e+13	77	< 0.1%
5.605572e+12	77	< 0.1%
1.3265725e+13	76	< 0.1%
1.6808908e+13	74	< 0.1%
1.0627791e+13	73	< 0.1%
3.265392e+12	73	< 0.1%
1.2076338e+13	68	< 0.1%
1.8233963e+13	68	< 0.1%
1.4092821e+13	66	< 0.1%
2.9055907e+13	66	< 0.1%
3.4882134e+13	66	< 0.1%
1.349609e+12	65	< 0.1%
1.5427788e+13	64	< 0.1%
1.342356e+13	63	< 0.1%
Other values (1180380)	2351680	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
455000107	1	< 0.1%
3129000153	1	< 0.1%
3251000120	1	< 0.1%
3574000113	5	< 0.1%
5058000128	2	< 0.1%
6486000175	1	< 0.1%
6817000177	1	< 0.1%
8151000196	1	< 0.1%
9290000134	1	< 0.1%
1.04780001e+10	1	< 0.1%

Value	Count	Frequency (%)
9.7711797e+13	2	< 0.1%
9.7711795e+13	1	< 0.1%
9.7554556e+13	1	< 0.1%
9.7554536e+13	2	< 0.1%
9.7554451e+13	1	< 0.1%
9.7554442e+13	1	< 0.1%
9.7554433e+13	1	< 0.1%
9.7554425e+13	1	< 0.1%
9.7554336e+13	2	< 0.1%
9.7554233e+13	2	< 0.1%

PJ_SITUACAO
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	1736950
0	616701

Common Values
Chart

Value	Count	Frequency (%)
1	1736950	73.8%
0	616701	26.2%

PJ_SITUACAO_RFB
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	2177479
0	176172

Common Values
Chart

Value	Count	Frequency (%)
1	2177479	92.5%
0	176172	7.5%

PJ_PORTE
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	1451103
2	691799
3	210749

Value	Count	Frequency (%)
1	1451103	61.7%
2	691799	29.4%
3	210749	9.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Overview of Unicode Properties

Unique unicode characters	3
Unique unicode categories	1 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
1	1451103	61.7%
2	691799	29.4%
3	210749	9.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2353651	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	1451103	61.7%
2	691799	29.4%
3	210749	9.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2353651	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
1	1451103	61.7%
2	691799	29.4%
3	210749	9.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2353651	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
1	1451103	61.7%
2	691799	29.4%
3	210749	9.0%

PJ_SETOR
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	1020903
2	946508
3	378545
4	7695

Value	Count	Frequency (%)
1	1020903	43.4%
2	946508	40.2%
3	378545	16.1%
4	7695	0.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Overview of Unicode Properties

Unique unicode characters	4
Unique unicode categories	1 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
1	1020903	43.4%
2	946508	40.2%
3	378545	16.1%
4	7695	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2353651	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	1020903	43.4%
2	946508	40.2%
3	378545	16.1%
4	7695	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	2353651	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
1	1020903	43.4%
2	946508	40.2%
3	378545	16.1%
4	7695	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2353651	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
1	1020903	43.4%
2	946508	40.2%
3	378545	16.1%
4	7695	0.3%

PJ_IDADE_ABERTURA
Real number (ℝ_≥0)

ZEROS

Distinct	71
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.794056553
Minimum	0
Maximum	89
Zeros	38132
Zeros (%)	1.6%
Memory size	18.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	6
Q3	10
95-th percentile	24
Maximum	89
Range	89
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	7.523914282
Coefficient of variation (CV)	0.9653399653
Kurtosis	5.774727618
Mean	7.794056553
Median Absolute Deviation (MAD)	3
Skewness	2.15934169
Sum	18344489
Variance	56.60928613
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	291992	12.4%
3	222202	9.4%
5	199013	8.5%
1	198969	8.5%
4	198132	8.4%
6	166470	7.1%
7	159981	6.8%
8	143990	6.1%
10	138977	5.9%
9	137676	5.8%
11	47916	2.0%
0	38132	1.6%
12	38098	1.6%
13	32744	1.4%
14	26506	1.1%
15	25691	1.1%
16	23757	1.0%
17	21070	0.9%
18	20953	0.9%
19	20483	0.9%
21	18945	0.8%
20	18889	0.8%
23	16552	0.7%
22	16103	0.7%
24	14529	0.6%
Other values (46)	115881	4.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	38132	1.6%
1	198969	8.5%
2	291992	12.4%
3	222202	9.4%
4	198132	8.4%
5	199013	8.5%
6	166470	7.1%
7	159981	6.8%
8	143990	6.1%
9	137676	5.8%

Value	Count	Frequency (%)
89	3	< 0.1%
79	1	< 0.1%
72	2	< 0.1%
71	2	< 0.1%
70	2	< 0.1%
69	2	< 0.1%
68	3	< 0.1%
64	2	< 0.1%
62	4	< 0.1%
61	13	< 0.1%

PJ_NUM_FUNCIONARIOS
Real number (ℝ_≥0)

Distinct	101
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.607879418
Minimum	0
Maximum	100
Zeros	591
Zeros (%)	< 0.1%
Memory size	18.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	10
Maximum	100
Range	100
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	5.486227972
Coefficient of variation (CV)	2.103712286
Kurtosis	91.258517
Mean	2.607879418
Median Absolute Deviation (MAD)	0
Skewness	7.879998476
Sum	6138038
Variance	30.09869736
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1718151	73.0%
2	205132	8.7%
3	86889	3.7%
5	66801	2.8%
4	59524	2.5%
10	32976	1.4%
6	31987	1.4%
8	21958	0.9%
7	19579	0.8%
20	13979	0.6%
9	12301	0.5%
12	11260	0.5%
15	9937	0.4%
11	6390	0.3%
13	5319	0.2%
14	4827	0.2%
30	4062	0.2%
16	3793	0.2%
19	3709	0.2%
18	3573	0.2%
17	2659	0.1%
25	2546	0.1%
22	2150	0.1%
40	1613	0.1%
21	1606	0.1%
Other values (76)	20930	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	591	< 0.1%
1	1718151	73.0%
2	205132	8.7%
3	86889	3.7%
4	59524	2.5%
5	66801	2.8%
6	31987	1.4%
7	19579	0.8%
8	21958	0.9%
9	12301	0.5%

Value	Count	Frequency (%)
100	695	< 0.1%
99	85	< 0.1%
98	35	< 0.1%
97	37	< 0.1%
96	28	< 0.1%
95	27	< 0.1%
94	5	< 0.1%
93	28	< 0.1%
92	60	< 0.1%
91	12	< 0.1%

PJ_UF
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.775776868
Minimum	1
Maximum	27
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	11
95-th percentile	20
Maximum	27
Range	26
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	6.111339127
Coefficient of variation (CV)	0.7859457943
Kurtosis	-0.04350017686
Mean	7.775776868
Median Absolute Deviation (MAD)	4
Skewness	0.9181389931
Sum	18301465
Variance	37.34846592
Monotocity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1	328695	14.0%
2	205573	8.7%
3	187624	8.0%
4	177616	7.5%
5	163855	7.0%
6	162294	6.9%
7	156848	6.7%
8	133572	5.7%
9	111138	4.7%
10	84503	3.6%
11	65072	2.8%
12	64676	2.7%
13	58946	2.5%
14	56733	2.4%
15	56028	2.4%
16	54145	2.3%
17	52809	2.2%
18	46428	2.0%
19	40948	1.7%
20	37377	1.6%
21	33984	1.4%
22	22050	0.9%
23	20403	0.9%
24	18721	0.8%
25	6977	0.3%
Other values (2)	6636	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	328695	14.0%
2	205573	8.7%
3	187624	8.0%
4	177616	7.5%
5	163855	7.0%
6	162294	6.9%
7	156848	6.7%
8	133572	5.7%
9	111138	4.7%
10	84503	3.6%

Value	Count	Frequency (%)
27	954	< 0.1%
26	5682	0.2%
25	6977	0.3%
24	18721	0.8%
23	20403	0.9%
22	22050	0.9%
21	33984	1.4%
20	37377	1.6%
19	40948	1.7%
18	46428	2.0%

CANAL_ATENDIMENTO
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.685390485
Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.185562501
Coefficient of variation (CV)	0.7034349083
Kurtosis	3.090405236
Mean	1.685390485
Median Absolute Deviation (MAD)	0
Skewness	1.93639531
Sum	3966821
Variance	1.405558444
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	1532424	65.1%
2	430036	18.3%
3	157535	6.7%
4	107106	4.6%
5	86004	3.7%
6	40546	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1532424	65.1%
2	430036	18.3%
3	157535	6.7%
4	107106	4.6%
5	86004	3.7%
6	40546	1.7%

Value	Count	Frequency (%)
6	40546	1.7%
5	86004	3.7%
4	107106	4.6%
3	157535	6.7%
2	430036	18.3%
1	1532424	65.1%

TEMA_ATENDIMENTO
Real number (ℝ_≥0)

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.368828684
Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	6
95-th percentile	13
Maximum	29
Range	28
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.22602995
Coefficient of variation (CV)	0.9673141834
Kurtosis	2.964315343
Mean	4.368828684
Median Absolute Deviation (MAD)	1
Skewness	1.724336387
Sum	10282698
Variance	17.85932914
Monotocity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	609708	25.9%
2	588716	25.0%
3	240909	10.2%
4	136561	5.8%
5	136083	5.8%
6	95135	4.0%
7	94326	4.0%
8	80918	3.4%
9	69103	2.9%
12	55918	2.4%
10	50402	2.1%
11	47076	2.0%
13	46134	2.0%
14	21402	0.9%
17	19726	0.8%
15	15167	0.6%
16	14606	0.6%
18	6652	0.3%
19	6132	0.3%
20	4624	0.2%
21	3821	0.2%
22	3811	0.2%
23	3410	0.1%
24	777	< 0.1%
25	749	< 0.1%
Other values (4)	1785	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	609708	25.9%
2	588716	25.0%
3	240909	10.2%
4	136561	5.8%
5	136083	5.8%
6	95135	4.0%
7	94326	4.0%
8	80918	3.4%
9	69103	2.9%
10	50402	2.1%

Value	Count	Frequency (%)
29	243	< 0.1%
28	345	< 0.1%
27	585	< 0.1%
26	612	< 0.1%
25	749	< 0.1%
24	777	< 0.1%
23	3410	0.1%
22	3811	0.2%
21	3821	0.2%
20	4624	0.2%

ABORDAGEM_ATENDIMENTO
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	2269889
2	83762

Value	Count	Frequency (%)
1	2269889	96.4%
2	83762	3.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Overview of Unicode Properties

Unique unicode characters	2
Unique unicode categories	1 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
1	2269889	96.4%
2	83762	3.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2353651	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	2269889	96.4%
2	83762	3.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2353651	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
1	2269889	96.4%
2	83762	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2353651	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
1	2269889	96.4%
2	83762	3.6%

CATEGORIA_ATENDIMENTO
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.0 MiB

1	1300681
2	1052970

Value	Count	Frequency (%)
1	1300681	55.3%
2	1052970	44.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Overview of Unicode Properties

Unique unicode characters	2
Unique unicode categories	1 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
1	1300681	55.3%
2	1052970	44.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2353651	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	1300681	55.3%
2	1052970	44.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	2353651	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
1	1300681	55.3%
2	1052970	44.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2353651	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
1	1300681	55.3%
2	1052970	44.7%

INSTRUMENTO_ATENDIMENTO
Real number (ℝ_≥0)

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.580884337
Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	5
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8771976486
Coefficient of variation (CV)	0.5548778163
Kurtosis	1.322411484
Mean	1.580884337
Median Absolute Deviation (MAD)	0
Skewness	1.400927024
Sum	3720850
Variance	0.7694757146
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
1	1500464	63.8%
2	422274	17.9%
3	369734	15.7%
4	39259	1.7%
5	21920	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1500464	63.8%
2	422274	17.9%
3	369734	15.7%
4	39259	1.7%
5	21920	0.9%

Value	Count	Frequency (%)
5	21920	0.9%
4	39259	1.7%
3	369734	15.7%
2	422274	17.9%
1	1500464	63.8%

MEIO_ATENDIMENTO
Real number (ℝ_≥0)

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.711006857
Minimum	1
Maximum	18
Zeros	0
Zeros (%)	0.0%
Memory size	18.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	9
Maximum	18
Range	17
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.656998895
Coefficient of variation (CV)	0.9800782642
Kurtosis	5.874512764
Mean	2.711006857
Median Absolute Deviation (MAD)	1
Skewness	2.395003968
Sum	6380764
Variance	7.059643126
Monotocity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
1	927195	39.4%
2	774296	32.9%
3	162898	6.9%
4	122356	5.2%
5	93955	4.0%
6	68728	2.9%
7	34412	1.5%
8	34186	1.5%
9	28361	1.2%
10	26985	1.1%
11	26112	1.1%
12	19482	0.8%
13	17743	0.8%
14	6258	0.3%
15	6012	0.3%
16	3879	0.2%
17	560	< 0.1%
18	233	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	927195	39.4%
2	774296	32.9%
3	162898	6.9%
4	122356	5.2%
5	93955	4.0%
6	68728	2.9%
7	34412	1.5%
8	34186	1.5%
9	28361	1.2%
10	26985	1.1%

Value	Count	Frequency (%)
18	233	< 0.1%
17	560	< 0.1%
16	3879	0.2%
15	6012	0.3%
14	6258	0.3%
13	17743	0.8%
12	19482	0.8%
11	26112	1.1%
10	26985	1.1%
9	28361	1.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	CPF	PF_SITUACAO	PF_SITUACAO_RFB	PF_IDADE	PF_GENERO	PF_UF	CNPJ	PJ_SITUACAO	PJ_SITUACAO_RFB	PJ_PORTE	PJ_SETOR	PJ_IDADE_ABERTURA	PJ_NUM_FUNCIONARIOS	PJ_UF	CANAL_ATENDIMENTO	TEMA_ATENDIMENTO	ABORDAGEM_ATENDIMENTO	CATEGORIA_ATENDIMENTO	INSTRUMENTO_ATENDIMENTO	MEIO_ATENDIMENTO
0	4.650267e+09	1	1	45	1.0	13	2.055678e+13	1	1	1	2	6	1	13	1	5	1	2	1	2
1	1.306666e+09	1	1	31	0.0	3	7.338788e+12	0	1	3	1	13	1	3	1	2	1	2	1	2
2	2.780436e+10	1	1	59	1.0	4	3.311693e+13	1	1	1	2	1	1	4	1	1	1	2	1	2
3	1.200526e+09	1	1	39	0.0	1	2.616854e+13	1	1	2	2	4	5	1	1	3	1	1	1	1
4	7.542230e+10	1	1	43	1.0	14	3.354560e+13	0	1	1	1	1	1	14	1	1	1	2	1	2
5	4.166229e+10	1	1	49	0.0	5	1.720109e+13	1	1	1	2	8	1	5	1	13	1	2	3	2
6	9.174883e+09	1	1	39	0.0	2	2.663826e+13	1	1	1	2	4	1	2	4	5	1	2	1	1
7	8.280314e+09	1	1	46	1.0	9	3.249453e+13	1	1	1	2	1	1	9	1	1	1	2	3	2
8	1.214082e+09	1	1	34	0.0	2	2.152293e+13	0	1	1	1	6	1	2	1	1	1	2	1	6
9	6.171112e+09	1	1	21	1.0	12	3.453417e+13	1	1	1	2	1	1	12	1	2	1	2	3	2

Last rows

	CPF	PF_SITUACAO	PF_SITUACAO_RFB	PF_IDADE	PF_GENERO	PF_UF	CNPJ	PJ_SITUACAO	PJ_SITUACAO_RFB	PJ_PORTE	PJ_SETOR	PJ_IDADE_ABERTURA	PJ_NUM_FUNCIONARIOS	PJ_UF	CANAL_ATENDIMENTO	TEMA_ATENDIMENTO	ABORDAGEM_ATENDIMENTO	CATEGORIA_ATENDIMENTO	INSTRUMENTO_ATENDIMENTO	MEIO_ATENDIMENTO
2353641	4.062365e+10	1	1	54	0.0	10	2.452559e+13	0	1	1	2	4	1	10	1	12	1	2	3	2
2353642	4.171359e+09	1	1	31	1.0	8	1.664272e+13	1	1	2	1	8	3	8	2	3	1	1	2	1
2353643	9.114684e+08	1	1	38	0.0	11	3.094719e+13	1	1	1	3	2	1	11	1	2	1	1	1	1
2353644	3.556089e+10	1	1	62	1.0	1	2.244326e+13	1	1	1	3	5	1	1	2	1	1	2	1	2
2353645	6.024705e+10	1	1	32	0.0	18	1.713113e+13	0	0	1	1	8	1	18	1	5	1	1	1	1
2353646	1.682244e+09	1	1	34	1.0	21	8.898144e+12	0	1	3	2	13	14	21	1	11	1	1	1	1
2353647	4.244522e+08	1	1	34	1.0	3	2.664215e+13	1	1	2	1	4	5	3	3	7	2	1	4	1
2353648	8.689250e+10	1	1	46	0.0	21	2.390253e+13	1	1	1	1	4	1	21	1	2	1	1	1	3
2353649	9.989666e+10	1	1	38	1.0	10	2.462663e+13	1	1	3	1	4	5	10	1	2	1	1	1	1
2353650	8.505110e+09	1	1	42	0.0	2	9.302682e+12	1	1	2	1	12	5	2	2	1	1	1	2	1

Most frequent

	CPF	PF_SITUACAO	PF_SITUACAO_RFB	PF_IDADE	PF_GENERO	PF_UF	CNPJ	PJ_SITUACAO	PJ_SITUACAO_RFB	PJ_PORTE	PJ_SETOR	PJ_IDADE_ABERTURA	PJ_NUM_FUNCIONARIOS	PJ_UF	CANAL_ATENDIMENTO	TEMA_ATENDIMENTO	ABORDAGEM_ATENDIMENTO	CATEGORIA_ATENDIMENTO	INSTRUMENTO_ATENDIMENTO	MEIO_ATENDIMENTO	count
1417	7.514879e+09	1	1	31	1.0	7	3.063645e+13	0	1	1	1	2	1	7	6	1	1	1	2	1	4
797	3.683213e+09	1	1	32	0.0	8	2.220708e+13	0	1	1	1	5	1	8	2	12	1	2	3	5	3
886	4.246570e+09	0	1	31	0.0	8	2.171820e+13	0	1	1	2	5	1	8	2	12	1	2	1	5	3
3565	6.071486e+10	0	1	49	0.0	8	3.288509e+13	0	1	1	2	1	1	8	2	12	1	2	3	5	3
0	3.666174e+06	1	1	32	1.0	6	2.936440e+13	0	1	1	3	2	1	6	4	3	1	1	1	1	2
1	5.382726e+06	1	1	54	1.0	2	3.611943e+13	0	1	3	3	30	32	2	2	12	1	2	1	1	2
2	6.635733e+06	1	1	53	0.0	2	2.001660e+13	0	1	1	1	6	1	2	2	12	1	1	2	1	2
3	1.479726e+07	1	1	33	0.0	3	1.445328e+13	1	1	2	3	9	1	3	3	3	2	1	4	1	2
4	1.529021e+07	1	1	30	0.0	23	3.600925e+13	0	1	2	1	0	5	23	4	3	1	2	2	10	2
5	2.514673e+07	1	1	54	0.0	2	2.051776e+13	1	1	1	3	6	1	2	2	12	1	2	1	1	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent